Update Row Item
AutomatR.DefaultActivities.Datatable.UpdateRowItem
The "Update Row Item" activity in AutomatR allows you to assign a specified value to the indicated column of a DataTable row. This activity is useful for updating specific values within a DataTable, enhancing the flexibility of data manipulation in your workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Column Index | Enter the number (index) of the column to be updated. Integer variable or argument. |
| Column Name | Enter the name of the column to be updated. String variable or argument. |
| Data Table | Enter the DataTable variable to update values. DataTable variable or argument. |
| Row Index | Enter the row index where you want to update the row item. Integer variable or argument. |
| Value | Enter the value as a string to be written to the indicated column. String variable or argument. |
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variable or argument containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Update Row Item" activity. This can be useful for handling synchronization issues. Integer variable or argument containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Result | Returns the DataTable with updated values. DataTable variable or argument. |
How to use:
- Drag and drop the "Update Row Item" activity onto the workflow.
- Configure the properties by specifying the DataTable variable, row index, column name or index, and the value to be assigned.
- Optionally, configure the delay and customize the display name.
- Execute the workflow to update the specified row item in the DataTable.
Example: Consider an example where the "Update Row Item" activity is used to update the "Salary" column value in the third row of a DataTable named "employeeData":
Update Row Item:
Display Name: "Update Salary"
Data Table: employeeData
Row Index: 2
Column Name: "Salary"
Value: "60000"
Result: updatedEmployeeData
In this example, the activity updates the "Salary" column value in the third row of the "employeeData" DataTable to "60000". The result of the operation is stored in the "updatedEmployeeData" DataTable variable for further use in the workflow.